Helpful Information
 
 
Category: CSV
PHP --> MySQL --> CSV -->

The titled was inspired by annother user...ANY WAY!

How do I dump all my data from mySQL using PHP to a CSV file?
for example (like you need one)
I have a table named Ezine, and it has 2 columns, Name, and Email


"Name", "Email"
"Jonathan", "biodegradabl@gmail.com"
"Fred", "yupthisoworks@hotmail.com"

SELECT x, y, z INTO OUTFILE 'some/file' (http://dev.mysql.com/doc/refman/5.0/en/select.html) is the SQL command you're after.

--Simon










privacy (GDPR)